Default column lengths for some data types, such as Microsoft Access files or Microsoft Excel files, might appear to be longer than necessary when using the Import Data task in SAS Enterprise Guide. The default column lengths should be determined by the length of the data value defined in the data source and by the encoding determined by the operating system and language of the SAS System server.

In most cases the default lengths are correct, but you can manually change the length by selecting Column Options in the Import Data task, and then change the value of the Length column property.

Operating System and Release Information